Show All
Add, edit, or delete detail data
If you can't add, edit, or delete data in a PivotTable list, it means one of the following:
- The properties on the Protection tab of the Commands and Options dialog box have been set to prevent additions, edits, or deletions.
- The field you are trying to edit is a read-only field, and does not support edits.
- The underlying table does not have a primary key.
Add data
- Click a cell in the blank row marked with an asterisk (*).
- Type the data you want in the first field, and then press TAB to move to the next field.
- Do one of the following:
- Press ENTER to save the record and move to the next record.
- Press ESC to leave the record without saving it.
Edit data
- Click the cell that you want to edit.
- Type the new value.
- Do one of the following:
- Press ENTER to save the record and move to the next record.
- Press ESC to leave the record without saving it.
Delete data
- Do one of the following:
- To delete the contents of a cell, click the cell and press DELETE.
- To delete a record, click the leftmost cell of the record, and then press DELETE.
- To delete multiple records, click the leftmost cell of the record, drag the mouse pointer to the last cell of the last record, and then press DELETE.
Notes
- When entering data for a field that has a number format applied to it, you need not type formatted data. When you leave the cell, the format will be automatically applied to the cell contents.
- Only detail cells can be edited directly in the PivotTable list. To change a caption or the title, use the Commands and Options dialog box.